1 and infinity not on line between tables due to no referential integrity.
Cause:
Referential integrity is not enforced; therefore, there is a plain join line between the two tables in the Relationships window. This is by design of Microsoft Access 7.0.
Solution:
To enforce referential integrity when defining a relationship, select the 'Enforce Referential Integrity' check box in the 'Relationships' dialog box.
(Optional) To enforce referential integrity when creating a relationship:
1) If the Database window is not active, activate the Database window.
2) Select the 'Tools' menu and select 'Relationships'. (The Relationships window appears. If there are no relationships currently in the database, the Show Table dialog box appears on top of the Relationships window. Add the desired tables to the Relationships window, and close the dialog box.)
3) Select the field in the first table to be in the relationship.
4) Drag the field from the first table on top of the field from the second table to be in the relationship.
5) Release the mouse button. (The Relationships dialog box appears.)
6) Do the following:
a) Click in the column representing the first table.
b) Click the arrow. (A drop-down list appears.)
c) Select the correct field for the first table from the drop-down list.
d) Click in the column representing the second table.
e) Click the arrow. (A drop-down list appears.)
f) Select the correct field for the second table from the drop-down list.
g) (Optional) Click 'Join Type...' to change the join type or to read an explanation of the different join types.
7) Select the 'Enforce Referential Integrity' check box.
Enforce Referential Integrity
8) (Optional) Select the 'Cascade Update Related Fields' check box to automatically update the related table fields when the primary key of the primary table is changed.
9) (Optional) Select the 'Cascade Delete Related Records' check box to prevent changes from being made to the primary key of the primary table when there are related records in the related table.
10) Click 'OK'. (The Relationships dialog box closes, and the Relationships window reappears.)
Relationships window
11) (Optional) Select the 'File' menu and select 'Save' to save the layout.
12) When finished, select the 'File' menu and select 'Close' to close the Relationships window.
